OPTIONS (skip=1,rows=500)
Load data
INFILE "../sqlldr_csv/aa123_1673486319145_manual.txt"
insert
into table   hqlnd.TB_INVC_GOOD_TEMP_20230607
FIELDS TERMINATED BY '^' OPTIONALLY ENCLOSED BY '!'
TRAILING NULLCOLS
(
id,
invc_code,
invc_nm,
invc_desc,
invc_keywords,
mclss_nm,
tax_rate,
duty_free,
is_bottom
)
